Export Entered Numbers To File

[DenDirect]

Good day all,

 

I have a quastion we use here voiceguide and it all works perfect.

But the thing we want to have is that people can type there number in and that the number is exported to an MS exel file like *.xls or *.csv is this possible? i know that they can type there number and that it is beiing verifyed but i want to export it.

 

Please HELP !!!

 

Thanks,

 

Regards DenD

[SupportTeam]

There are some examples of reading/saving from/to Excel files using VBScript in the help file. See: http://www.voiceguide.com/vghelp/html/modVbs.htm

[Guest rajendrarajsri]

Hey,

If you dont want to go to net, you may also find it in your machine if Voiceguide inatalled. Start-->Programms-->VoiceGuide-->User's Guide-->Modules References-->RunVBScript

You may find here so many usefull vb scripts.

rajendrarajsri@yahoo.co.in

[DenDirect]

Thanks but when i type this in the vb script:

 

Const ForReading = 1

Const ForWriting = 2

Const ForAppending = 8

set fso = CreateObject("Scripting.FileSystemObject")

set tsFile = fso.OpenTextFile("C:\LogCalls.txt", ForAppending, True)

tsFile.WriteLine "$RV[EnterClientNumber]"

tsFile.Close

set tsFile = Nothing

set fso = Nothing

 

 

Than it still doesnt work the file logcalls.txt stay's empty??

any idea what i do wrong?

 

Regards DenD

[fluffybunny]

If you are simply writing a number to an Excell spreadsheet (i.e. not reading information from the spreadsheet to be spoken to the caller) then you could use the DDE Send module instead of getting wrapped up in VBS.

 

This module sets up a DDE link to the spreadhseet and can write values to specific cells in the sheet.

 

Its cheap and cheerful but seems to work.

[Guest rajendrarajsri]

Hello,

This script will work only when the file exist. If the file does not exost then you have to open the file "for writing" instead of "for appending". I think this will work.

 

rajendrarajsri@yahoo.co.in